UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 's6H6rfWXtqmUTE0BBJ0arNf2gfUj78aJab3nMu+ofSM='
WHERE
key_id = '19b5011815ab38a9ad0c472806e9868c1f6b0616935df311b5c2a3a34f13ca45'
AND (
token = 's6H6rfWXtqmUTE0BBJ0arNf2gfUj78aJab3nMu+ofSM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)