UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VsYmCZAHRkMiNrxB427/yvK37c6O9htlATn4gSBaqwg='
WHERE
key_id = '455c6400614ff807e627deb891fc1f4a31ad9e5036758e3f59c954744a56a8ba'
AND (
token = 'VsYmCZAHRkMiNrxB427/yvK37c6O9htlATn4gSBaqwg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)