UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f6m7iYTFvyQHI5Subf0DV6A55ISGnJYT79tejK7yUfk='
WHERE
key_id = '20e705a56a7ca51b848a8da63898371c929fc3f2e2284c02cbb8576ae0e65c46'
AND (
token = 'f6m7iYTFvyQHI5Subf0DV6A55ISGnJYT79tejK7yUfk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)