UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pDZiHsTgMsMX+3X7X2Wvai3LYMsn7fhUPb1r0NMRMxU='
WHERE
key_id = '57fa5ef095c8337a58079d7d04d5513b6cbce36955a4fe8ebfee608a0a07bffd'
AND (
token = 'pDZiHsTgMsMX+3X7X2Wvai3LYMsn7fhUPb1r0NMRMxU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)