UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pKKcoQejaTqF3C87TqiQcUNJd2PVOVPBh1cvc3/iTkc='
WHERE
key_id = '42a1514d2b5a723afc4744e452545301d2636496e5e1731c8d46077b47bbfd6c'
AND (
token = 'pKKcoQejaTqF3C87TqiQcUNJd2PVOVPBh1cvc3/iTkc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)