UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/4D1xZ6w66SeskzCIIoaowMc5UOhgyR9UYvVjNo2JBM='
WHERE
key_id = '877f7fdbe4f118958c62fcf6df5cb664b882f8977844a53bad4e0faed9c812cc'
AND (
token = '/4D1xZ6w66SeskzCIIoaowMc5UOhgyR9UYvVjNo2JBM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)