UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Dx6o+iAvlb01l6Z+VAGlVAIM2E7PnRW9noCRmyrw+ck='
WHERE
key_id = 'c75cdaba9d05b0daddf9c66956f0351b1a93166021c861e69734089627d6f293'
AND (
token = 'Dx6o+iAvlb01l6Z+VAGlVAIM2E7PnRW9noCRmyrw+ck='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)