UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1BiJ9X2TM7bFrvgbeNJIt23LGhL0SWgyptzImzOJLV8='
WHERE
key_id = 'b60cbc012a36e7ef6fedb0a5983d72386de09c3154421d2e9d0870924aff432e'
AND (
token = '1BiJ9X2TM7bFrvgbeNJIt23LGhL0SWgyptzImzOJLV8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)