UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZFmKD1doQOUFVT89Z26kuzrSajmwB57c29RQRGFn1Co='
WHERE
key_id = '187bd8a44aba0b58cd1890f9c3a6fbfc11cf0db085078c2d09c18c2c09dd3dff'
AND (
token = 'ZFmKD1doQOUFVT89Z26kuzrSajmwB57c29RQRGFn1Co='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)