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