UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oL1K4MNgrQE/5dy7T8KqW96FXBCae9qAsDLmezfpj7o='
WHERE
key_id = 'a64770868527cb4b2c56c98679dd8083e30368685e68ecd7484167c8e025eab6'
AND (
token = 'oL1K4MNgrQE/5dy7T8KqW96FXBCae9qAsDLmezfpj7o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)