UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XtcJw1pKa+hcaSEPSI25qC3aAKzGaGrbUPf+NHLv/eE='
WHERE
key_id = 'd0df0cb89e9002a0f4363822663a6804ebde659527007e1ab147082f530d402d'
AND (
token = 'XtcJw1pKa+hcaSEPSI25qC3aAKzGaGrbUPf+NHLv/eE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)