UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '16bvlXL5Zsqv3tlvC0a0u8uSvnO2OlyMVSjfHf24gik='
WHERE
key_id = '8b01e6dc587b6bdd8d5f2c6cdfddd6047161e32474dbfdc4caf944d5d5d4f530'
AND (
token = '16bvlXL5Zsqv3tlvC0a0u8uSvnO2OlyMVSjfHf24gik='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)