UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RBoUdDQF7wMMKyJt1Mc8W47HohYbiN3tnAv7KdmXyfA='
WHERE
key_id = 'a2ac20efe00d9d1459897d392991868feaf33abaaca990652c484a849c64fed3'
AND (
token = 'RBoUdDQF7wMMKyJt1Mc8W47HohYbiN3tnAv7KdmXyfA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)