UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8R+l7I0ABWdUJDAijncQLxN/l+XamTww2T3yWxTDIrw='
WHERE
key_id = 'ad18fb85215bb854eab6a6eaec3aae8bdea0c31844da4026383e347c6f9029bf'
AND (
token = '8R+l7I0ABWdUJDAijncQLxN/l+XamTww2T3yWxTDIrw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)