UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c4O1c2dGWBqqc5NsyKY/oinAEYlYmZe6YVQE169z5zU='
WHERE
key_id = 'e97beacbea130a1887f7caf1fa8fbe990894b6770c7b535ea5e1dc3aca511c7c'
AND (
token = 'c4O1c2dGWBqqc5NsyKY/oinAEYlYmZe6YVQE169z5zU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)