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