UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wvC7QgX86PwG2KbqjIlnYCDnCnz5t5vXSx8znvyCgTM='
WHERE
key_id = '787d4bda429fcb1ada34255f41f6cc73d688d35292861ef4efe513f66b5ebe5c'
AND (
token = 'wvC7QgX86PwG2KbqjIlnYCDnCnz5t5vXSx8znvyCgTM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)