UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AOrHiVsjTEIWSHUR8ioICbXxUQSkI8l7ibybE9etOy4='
WHERE
key_id = '5ccdcff6c0ca4f25c92e19b3b6e37336ec79fb07f148d04241b2fbe270862a24'
AND (
token = 'AOrHiVsjTEIWSHUR8ioICbXxUQSkI8l7ibybE9etOy4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)