UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cuga9BN9t6QVfr48BFfWhW4Z3dHC8ow4hg02k+fxBvs='
WHERE
key_id = 'd8be3f3d7e1970f871a713fe7d1b78292e5b3e9e832d1b7509400c7c6e42cd53'
AND (
token = 'cuga9BN9t6QVfr48BFfWhW4Z3dHC8ow4hg02k+fxBvs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)