UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PqFcqPXLdJez9GoG8oHzenTHdQTHvLHX75PPPTTb9Js='
WHERE
key_id = '8de00e7050b3db7d23c071fa9421a04ea140e5f90224f343ccd27c1d48bfc597'
AND (
token = 'PqFcqPXLdJez9GoG8oHzenTHdQTHvLHX75PPPTTb9Js='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)