UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uERRPZUcWuimPsEUB60oiOJOhk3mCQvsV6vHlbMiWlI='
WHERE
key_id = 'bc6e9394d8216182b383dfcb6ebb48ae481fdfb0a653cde1ddcf64ba3e62b8d7'
AND (
token = 'uERRPZUcWuimPsEUB60oiOJOhk3mCQvsV6vHlbMiWlI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)