UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LZ2dTvBy1cPMMGmS7dmhk6xy1Z8CoXTRM1sGBNm9V6s='
WHERE
key_id = '3040bc8792ec38fc4927ac1115bc24d9bbaa5baf5fbfba05d125b9dc5e2b1e84'
AND (
token = 'LZ2dTvBy1cPMMGmS7dmhk6xy1Z8CoXTRM1sGBNm9V6s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)