UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tHxhtxaVqIx8zsQefe4rzYf4FpeVCIC/FoTZ0Km3A0o='
WHERE
key_id = '5787e814284fe34f6e1472682fcef63857945de35d7148c8a1ecf19ee5c59a19'
AND (
token = 'tHxhtxaVqIx8zsQefe4rzYf4FpeVCIC/FoTZ0Km3A0o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)