UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5rRpebicn/29c5Y24SzUXKrYgJ5jmgV85ioV4oCXTkU='
WHERE
key_id = '6d393ffec60b3fface5e6e459916ce60a52847037d627ea72ab580a33f315ad9'
AND (
token = '5rRpebicn/29c5Y24SzUXKrYgJ5jmgV85ioV4oCXTkU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)