UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QKZ7miXwrjaUx4jJPLzu/tLycVmpw4z2s23CbbSHwTg='
WHERE
key_id = 'e102bd6075993f4b90438f3a49063f0afc8f106958367058a7774aa3c0a7cccc'
AND (
token = 'QKZ7miXwrjaUx4jJPLzu/tLycVmpw4z2s23CbbSHwTg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)