UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NxPja1ub12bOp+jOPvmnyV6C1lfMZgXrfDxQaw28Mrs='
WHERE
key_id = '111c6f4e143f2c3aefdc86d78a60d79654c2575ad5547a2db44c7d90de36fe9d'
AND (
token = 'NxPja1ub12bOp+jOPvmnyV6C1lfMZgXrfDxQaw28Mrs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)