UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3abG2lkboXt9Nu2LqBrKxLpOJJYwaAICdlv02mpzvuA='
WHERE
key_id = '59a1d00c2ed4491d1daf68e177ae211f53854ebf876f4fe0908a282732c9d7c5'
AND (
token = '3abG2lkboXt9Nu2LqBrKxLpOJJYwaAICdlv02mpzvuA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)