UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oQ7sV0QDp9XWEC5EbFokJGUCpwVe5ZHhRN6PRZFMVVk='
WHERE
key_id = 'f1f068cff228c0a98e750e983bb1be85b8646da36f2db6d736156600e3f1bf11'
AND (
token = 'oQ7sV0QDp9XWEC5EbFokJGUCpwVe5ZHhRN6PRZFMVVk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)