UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XphJh9Va045bhSitXuIhfOxI2HvLSDGk+Kd/8Uj2Y7g='
WHERE
key_id = '011fa0fb9a42b4cae93523cea9c0899eb825783e2238111319ac91fdd9004a88'
AND (
token = 'XphJh9Va045bhSitXuIhfOxI2HvLSDGk+Kd/8Uj2Y7g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)