UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9HUKIHLqej6Vf180qsbMhQlYhz9AFujXkiEShqMYOAo='
WHERE
key_id = '31f36ccb9d7df85c4a3d883797c6f22c5dd5108f7cba5b6779b3345691089253'
AND (
token = '9HUKIHLqej6Vf180qsbMhQlYhz9AFujXkiEShqMYOAo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)