UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HzUBoXkT6bdbDILdqr/ueHqKl3SpUlKIn+DG/eGnfMw='
WHERE
key_id = 'f83f631f9493247e078d442ec5bfe885aa31f19a67b7b2232fc9c5a9124ea9d8'
AND (
token = 'HzUBoXkT6bdbDILdqr/ueHqKl3SpUlKIn+DG/eGnfMw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)