UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DM/BpE7lJe7dftIs5wiQklGyCqhtpOaugZe+iWHUYsk='
WHERE
key_id = 'a11eda61cfadc1bd49710debaaf490d5e256442898390a1d0587e1a0c3ffeef4'
AND (
token = 'DM/BpE7lJe7dftIs5wiQklGyCqhtpOaugZe+iWHUYsk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)